﻿CREATE TABLE [dbo].[MobileRoleOwnFunctions] (
    [Id]         INT IDENTITY (1, 1) NOT NULL,
    [FunctionId] INT NULL,
    [RoleId]     INT NULL,
    CONSTRAINT [PK__MobileRo__3214EC07120C0F7E_Moebius] PRIMARY KEY CLUSTERED ([Id] ASC),
    CONSTRAINT [FK__MobileRol__Funct__14E87C29_Moebius] FOREIGN KEY ([FunctionId]) REFERENCES [dbo].[MobileFunctions] ([Id]),
    CONSTRAINT [FK__MobileRol__RoleI__16D0C49B_Moebius] FOREIGN KEY ([RoleId]) REFERENCES [dbo].[MobileRoles] ([Id])
);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'角色拥有的功能', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'MobileRoleOwnFunctions';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'功能Id', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'MobileRoleOwnFunctions', @level2type = N'COLUMN', @level2name = N'FunctionId';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'角色Id', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'MobileRoleOwnFunctions', @level2type = N'COLUMN', @level2name = N'RoleId';

